SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047108 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047108 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825840,584315,62551,499736,370333,645973,883148,520947,528160,559850,812673,74141,706665,1004121,158981,298464,653652,296447,652966,822378,985371,675125,99016,140441,959710,322328,733126,365367,969247,970307,140273,1019365,1031394,111940,1048853,994776,411733,683188,130875,326571,949619,603352,58473,487308,69915,791579,340451,837143,1006048,823083,1004654,486266,765343,364623,306516,35940,866138,436023,989654,664485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]