SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917640 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917640 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039579,458325,394666,54971,920244,763363,58526,705482,606678,88398,821837,728916,603422,147420,257466,226130,222709,190506,42219,1035856,763841,320339,693874,777111,1016009,188794,591057,145103,205442,477717,749271,696544,382257,331188,377108,16578,967424,71666,522920,236708,765245,301088,875572,130265,273343,177352,808711,367260,801354,337029,676010,1030760,261022,162197,1042741,441766,381353,732144,23835,631207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]