SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343499 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343499 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130474,989564,804995,419202,277781,521562,817048,318312,354424,335402,731291,13654,401116,353288,801983,1034068,677144,774579,136930,428018,558672,285998,266399,542859,609066,57274,22490,606117,541484,1033913,106185,435517,944230,187565,567052,811547,440395,254238,430511,513413,197183,796450,250799,706613,816230,594136,1066,284483,715349,1022347,25701,290955,839474,309827,22997,437644,156508,520758,829165,488753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]