SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495331 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495331 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913724,523847,461496,517453,193096,495193,1027052,476990,1018143,365672,195135,732922,361832,140138,780608,764023,238082,554115,403690,925329,896570,413353,55703,945049,477348,360223,774487,748171,969039,501734,937778,385365,174218,446635,788361,765144,932600,972880,425090,388654,748836,705657,1005820,701136,777125,524918,1042157,833076,600007,592661,183886,725823,151135,730320,680388,822106,932918,238387,1012329,610736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]