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` = 120448 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120448 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016793,152463,986123,573529,682717,1026283,99541,341700,401988,241505,345596,925939,933974,1037058,36501,781249,604700,964324,483554,242302,829087,442089,615800,413555,870569,533759,374441,917390,339469,554645,437418,788020,527074,923550,230334,118065,227018,628805,71704,384214,980538,13423,516081,714241,639659,990592,72376,121235,477477,1658,694907,371247,787867,855212,560854,186934,297459,272657,670364,865058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]