SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290800 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290800 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119984,374437,823958,135929,143981,496021,564337,1008759,371833,1033974,695483,969904,175571,490958,251597,899702,471550,550766,1026559,164401,890583,16462,1043384,439861,662241,381285,209814,738583,661526,439696,931279,411007,643565,33612,520418,598834,910472,995132,984613,269046,589688,888207,266281,287635,656752,652179,329661,397061,677946,836159,915341,891268,1012580,442760,1008068,493932,492167,368447,810325,351609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]