SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40011 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40011 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409609,981277,375966,825070,86658,729439,33647,769972,67535,162240,42789,785911,83108,544170,47646,624370,979399,492418,175748,421719,402407,734897,479530,196984,407479,386451,60199,19426,358674,266291,456010,81142,104940,247205,29176,221937,385035,928601,171906,624211,1013485,659268,785446,494319,310015,970044,93158,84323,390765,230721,504648,537433,904200,1018884,200767,200423,714705,365485,534163,186635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]