SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501422 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501422 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19471,921925,481426,68640,577175,730529,717237,100127,320236,664449,974659,226043,157853,117110,291863,627146,596461,445039,1045938,203056,280221,409328,120996,788031,793303,66136,254364,765997,159448,497805,745351,895405,807187,928778,956969,397085,261080,163529,480806,462522,268111,981445,630688,623749,384795,995928,490050,575147,53610,525926,241752,209406,368214,816547,565704,572153,316345,755976,67125,562223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]