SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017621 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017621 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173978,860253,536141,115423,407836,330253,938817,767079,894855,705201,914698,356806,155270,328396,546233,253929,684388,651244,703642,352605,864783,819990,14540,950285,812442,387028,811460,115136,377152,505283,231128,578706,410554,306199,835265,869032,75350,200579,15124,315390,101694,545225,246852,134975,127757,278179,534351,589362,802585,711696,201210,542302,540632,896029,125581,611135,275600,345315,973206,1040036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]