SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804766 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804766 [ RunTime:0.003310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429012,118101,211487,893788,160493,60716,341627,631219,982360,91012,14533,836932,768878,631495,923149,180252,617288,244039,354665,62599,363446,411489,877043,174487,913423,489712,684823,423372,377714,781138,696941,677614,483254,319708,423076,575162,630689,335094,9513,908119,1030601,920129,604643,855881,758367,1025154,751569,605957,569589,679401,726918,976978,566655,785103,149827,26192,592560,714312,274606,313866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]