SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542781 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542781 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632750,42093,289904,1047807,824519,570586,642232,80586,424789,436546,699191,973422,18467,20305,662253,35635,191724,106755,263356,254300,1030734,869694,737818,636061,410393,76970,548939,157729,231437,876749,247058,577928,504657,791483,411452,151577,149786,825414,75188,980571,332029,1011813,827329,785727,9045,593357,1018123,497,1000367,94258,584946,1025527,160497,541763,752758,569809,309580,1003030,729593,335433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007916s ]