SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436706 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436706 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756928,621989,525707,553187,790994,250155,257011,262034,655074,837785,674864,667443,19739,354080,960530,631691,579439,944700,330975,648196,792469,842945,177949,882328,595481,472768,415733,735610,954655,269231,409311,1015597,283160,688407,764190,1021540,249648,536719,549158,825944,103468,794290,88116,1023472,210887,681662,203190,1043080,1009221,475655,1033554,680596,531912,916480,541240,497915,599841,988887,902153,752297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]