SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470413 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470413 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593738,926788,856335,704845,822985,808367,220854,372269,724576,717888,468501,708162,1033868,624423,376783,947670,837838,494696,387144,593406,921889,673261,93559,781831,961955,534580,950810,551829,54165,796584,746495,736088,254656,235097,811634,510545,93323,580789,71146,873308,604509,381495,305728,651637,267218,159847,38023,1006169,546096,262808,984411,142650,937941,248504,541739,353683,250557,920568,488375,701697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]