SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509673 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509673 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429745,465280,157017,426054,318170,550394,172635,325642,248290,391164,751514,246400,564469,816839,818722,898915,293507,109391,4553,880321,566032,822642,382285,75671,657104,932501,426339,842998,814380,126930,133178,976652,1036654,344031,436825,917152,708185,103295,479137,9287,179219,311282,551118,7610,138865,517885,941965,135519,756311,633640,73304,667958,309953,898990,711212,530749,1030981,930363,767985,258998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002530s ]