SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415818 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415818 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822669,428877,794601,562076,216128,55081,927598,49151,2890,466311,388408,191861,737082,610697,317336,741700,121116,864690,364581,1005526,93226,867239,1019583,386347,75371,802344,730755,396894,259666,192352,347132,60655,27390,448,286190,166698,371064,665834,355855,526257,191964,976033,94654,99058,906799,846858,604671,309659,535119,776538,79101,849591,806807,538372,196024,789475,227579,631164,224658,405045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]