SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429728 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429728 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833192,662800,809167,925199,796040,771473,376986,315335,158694,1037604,16944,1006811,645865,704286,919427,26203,487152,583914,355590,936418,303717,686454,182660,455644,688891,833507,673536,603758,530963,51470,576368,812637,964795,598301,183838,306195,817099,310008,181829,1019869,246735,686635,50028,162306,143805,420985,453829,601172,448754,246170,835492,831124,519337,928165,156501,841962,756144,1021418,829013,669557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]