SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115049 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115049 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178073,509145,822413,313586,196639,1018178,244551,869820,460362,702908,1015460,986682,5994,286728,945258,14138,603361,228882,245316,404034,1015062,352675,383077,564765,293982,1036089,988798,615423,441286,1006940,776433,866330,236781,953398,848725,392496,947210,853488,379291,394887,653184,856763,18154,653442,210271,783582,714638,221645,1022312,134569,654682,495438,618166,64244,100156,455745,720268,805649,870831,330824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]