SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416481 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416481 [ RunTime:0.003741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889623,294558,656490,690942,267801,903606,276443,315707,424028,470962,691491,446910,238338,13867,517675,483945,1014010,821341,829372,201077,809215,269289,50579,961982,499632,240911,281648,299733,155185,239364,861961,697103,757689,631331,583426,205305,485702,511357,145733,314894,922185,864116,408994,396483,1009820,391716,830747,355254,402982,513377,873716,27524,676258,737363,252432,643398,398650,258803,308831,380760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]