SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519989 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519989 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520369,1023315,716501,937976,694461,320533,499680,786240,865848,490355,694455,1001408,946733,632103,161525,936712,671587,223153,521510,885790,110253,171004,511964,696530,739583,272301,156125,1036763,1013357,462710,756560,708196,740335,953226,404474,155098,352587,609963,978033,444806,402884,610390,671569,886233,98341,491551,265607,757375,1034241,839140,323673,260070,964614,293894,855996,990912,325564,688743,97525,619761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]