SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565602 LIMIT 1 [ RunTime:0.001221s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565602 [ RunTime:0.002728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904503,1014760,65276,85275,1039227,493275,646030,88163,1044918,842091,204404,423682,770876,765568,711902,764582,521840,981557,186987,551505,723215,184112,554369,525949,491592,68655,1020442,128500,352138,766947,593006,309741,219271,223279,282435,1030670,679110,935118,223041,300190,729291,972393,554969,314613,703700,806367,1021974,930919,704358,604906,559510,698198,986644,102478,364238,949931,1023500,179306,584960,935159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]