SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595854 LIMIT 1 [ RunTime:0.002342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595854 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409359,391016,425857,754054,327063,875227,1010439,890819,50015,131954,449922,439209,688798,910080,378875,940304,78670,246477,317001,390845,334974,6290,245753,693909,756926,445426,660895,823921,316246,1042160,632650,347182,78453,752482,774554,511326,223019,882262,686869,1006479,445248,50244,344421,748918,998591,638835,844159,800108,601626,721798,929116,912418,886218,864840,830498,416195,554166,14820,477537,125259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]