SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018971 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018971 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961458,539545,918995,17364,320220,819952,328071,616350,545094,750739,147125,614828,1000351,151094,830044,83624,816737,990727,153792,620933,809881,916596,306068,351470,652073,298388,779274,87537,735690,477316,526905,196331,897549,651248,432746,817841,509271,174540,837614,382551,1007006,30275,547827,694635,53738,82142,465893,372899,1034804,251064,810178,319185,595559,300404,29169,716280,459173,423236,177006,696775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000852s ]