SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297099 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297099 [ RunTime:0.004876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91244,277275,434116,317142,968437,185715,260154,517749,52668,124534,806854,745160,19807,644636,433355,250904,320873,151373,1019429,386901,728961,890898,790327,323015,223230,633484,27302,557155,142044,195523,483507,941645,1019933,60488,916650,190496,26135,32619,228609,696312,878458,888402,269145,744657,306073,283113,186857,573585,228741,367866,577874,352866,711419,1002667,427046,548103,380989,489985,448184,978988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]