SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80013 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80013 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60052,857557,655220,231440,832558,278513,484214,1029484,8081,289996,965411,327191,1046120,895312,618972,760146,194967,783347,202603,729385,418777,902085,736305,970728,598290,562385,602301,301070,560800,954689,513256,482806,291287,905984,129451,1018160,753263,94252,508571,103358,373841,219923,840177,568748,162241,629208,631834,534591,339360,555991,47415,317233,890588,818576,706882,564933,368053,1020075,1023993,453896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]