SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439855 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439855 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449898,851078,174134,153768,568130,1031319,253893,723407,508940,346672,30464,920250,421174,639900,803773,478312,546540,641341,644157,378220,503393,437406,145140,1019097,336527,94847,991565,89060,1027278,691082,456950,345192,360044,412790,849226,547101,311369,718980,825818,1003762,280210,655033,974588,251598,283541,873063,542258,29593,88975,1023667,451561,139376,541336,1033484,80849,468821,365805,607764,406772,318615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439855 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439855 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]