SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105226 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105226 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015361,41939,499610,348711,285744,984076,625618,199276,161310,224146,282520,875619,213077,450139,1019856,48475,109579,575692,724669,896731,990912,335700,432737,832938,841737,813805,529267,821062,764072,83878,88577,158886,37548,881719,24052,834383,690880,89890,140298,80589,1032246,860657,148141,516850,840178,268058,322686,636984,699315,1046473,655582,128831,978051,267725,688556,60334,247713,355285,616038,878409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]