SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261135 LIMIT 1 [ RunTime:0.001781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261135 [ RunTime:0.003179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751197,343015,142689,468271,1048084,1024208,251528,726286,189221,528434,240132,737052,481827,492129,840263,120708,323627,480431,298156,99162,543933,191769,666710,65216,280593,207738,1047885,564479,427136,551284,888091,779104,857905,787257,39659,471812,157147,422072,439136,402684,642448,205103,914794,813960,835070,387048,886070,668505,628120,190940,557495,134474,43908,438780,388250,259373,759330,905208,815219,24168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]