SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005080 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005080 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798232,929595,17303,571618,497523,219954,963238,177303,42936,396492,144525,790311,903799,984963,532054,822646,704993,776688,410662,394216,1033096,953318,969515,188216,11559,116849,274266,101000,967994,957685,48798,120380,678256,584931,596788,238696,933695,277045,28140,962456,470475,1030370,618052,904224,197227,616002,12463,1001461,907895,877635,113163,580627,49357,572212,785331,941840,536417,318801,307139,814854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]