SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532948 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532948 [ RunTime:0.004456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415266,682318,242029,54982,304057,335046,7760,658532,810805,336853,546654,726034,82990,405159,563522,5183,332542,108601,426168,314338,544870,562747,896877,655895,891228,896150,238171,445806,225324,615090,730739,829287,270820,872074,218627,180002,338809,471964,926627,298493,1015126,1041389,334823,889119,514897,982153,489027,741366,433050,510898,67918,9824,730086,929752,876585,413368,565349,255588,737036,72262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004140s ]