SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516610 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516610 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611973,756546,967425,298852,716697,63782,644876,671109,696111,166391,245808,939751,793142,69622,838930,622677,875541,377090,448496,104659,795319,823937,728108,1006201,515476,985897,302840,360800,868266,846538,754533,837906,835780,41804,539913,1028432,480997,232319,487525,202183,648079,343366,714138,1027662,955751,1032495,179708,530210,24319,299886,94545,170666,726004,400612,188111,563197,731793,434806,518306,602319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]