SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195975 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195975 [ RunTime:0.002543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474954,783068,687488,521493,460292,216213,605270,303542,501543,315522,1014050,543277,1009336,803661,97043,63048,56191,315976,520531,159490,224728,1022624,882073,136965,49851,659209,685107,971160,285525,138086,109788,782180,128643,609324,901584,685820,239736,312751,762875,871139,400703,674432,426879,245602,722943,268749,85129,681089,421617,785498,213835,356820,708107,229618,992008,1046879,618489,499590,889923,343600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001199s ]