SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413809 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413809 [ RunTime:0.003005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306179,433013,798670,406261,852683,483984,181026,529978,242098,829745,145182,108495,279971,539849,562134,480631,292134,703272,856384,935198,858659,881924,46544,652468,601445,737209,632482,429188,932414,909545,1026583,336126,74968,981471,68944,677101,1021943,438065,136319,491212,814095,990508,108656,190125,673509,720887,830502,326305,16491,701129,486563,163967,475406,304399,261459,796090,544266,1004222,19559,291565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]