SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611181 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611181 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36418,122623,621841,418333,984450,276996,102050,312433,547736,552695,298734,202449,990740,882748,794791,1033629,227025,803060,877627,434672,193244,765251,684985,651631,311584,505080,919245,507604,407624,303222,234061,860512,472037,206246,115100,329612,721635,291538,771263,122881,25730,675960,171314,24782,1038826,216366,286381,647862,444025,162497,498296,282450,487606,857733,722514,269400,561998,683536,235461,960887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]