SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261346 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261346 [ RunTime:0.003158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520321,494052,2911,1043639,817965,663599,336196,1041549,869223,990072,527597,253623,228961,635635,526275,44904,497088,216685,67671,985689,440325,252096,409135,591076,873257,71330,348408,1017343,690942,174112,1044375,366662,497714,209865,342474,612774,186809,824060,285045,535954,220577,24991,1039998,754613,812337,547653,565265,105285,125889,352350,207099,833424,835598,239532,705539,532825,914545,464973,267037,762662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]