SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002896s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425243 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425243 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249123,268127,287771,869143,849593,382800,332124,539206,68260,733121,281915,794834,693046,381563,728888,601671,303024,289480,495441,138168,320512,1018949,766078,113090,240832,277894,44339,482853,948804,845923,474599,752254,151426,506131,666253,274734,847808,476638,432233,994693,833030,23307,1047614,998363,475141,238694,811691,502839,97617,937987,1019680,680125,212544,169480,579098,824388,314746,921571,156895,157010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]