SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405064 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405064 [ RunTime:0.002981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440072,802944,866100,13134,1036199,333691,441616,926112,400423,717404,125703,801277,199414,699486,377288,573862,683365,714952,575747,251397,955537,342291,379170,411414,255124,18820,756618,211322,969668,161849,539108,345603,891393,987015,880130,252362,247140,289397,456404,460680,248332,851753,404042,50148,887417,529159,1027405,331395,925191,483900,266397,232554,469988,401729,872756,966231,630167,211116,868142,661542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]