SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000452 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000452 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8975,249103,49920,666066,357642,230271,993217,990959,212223,518832,759910,572642,881519,981974,414464,245560,38753,542894,1042657,588980,14117,411361,164813,500073,93121,974995,37449,251398,880238,148493,153181,935150,767968,1002865,609838,977135,152812,90973,670122,311488,635894,781277,594639,848656,923733,234315,109123,881118,389766,820719,989824,235013,140164,1043756,1027321,575271,981798,670048,539063,450125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]