SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532611 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532611 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167872,702140,541642,249353,1018014,444879,158414,782751,700321,1027931,1009496,677945,751662,911204,851065,568865,667937,844249,34556,1027086,119542,137750,401538,873845,303786,1007521,848644,537864,56273,857569,702792,365884,280330,516594,813235,556298,669390,510618,695494,611086,301699,925864,513196,1014813,357018,13602,8893,165400,758219,520728,88316,457760,904480,173656,172566,430679,179033,377417,17434,444970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000901s ]