SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39750 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39750 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647120,290006,726222,168119,897984,1013374,914921,879647,130555,415794,1001353,416150,442674,864095,498114,604440,197705,204004,1036400,220011,871300,15328,842775,881095,577715,895389,592859,963368,25640,687997,166876,709237,406395,303251,137189,3805,1030601,305444,363766,1004387,254747,22576,586966,609249,255761,404867,185904,384401,742452,517880,132890,969542,1005219,76092,387756,239103,769116,734101,647164,568660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000936s ]