SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483051 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483051 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271151,321877,1014756,519314,860455,57784,157971,143100,531587,597929,36113,869786,639997,828898,37149,55027,707422,234082,1003507,153797,862234,739727,354455,497300,165287,589532,785873,191918,232346,799214,940136,799549,1028235,408372,815743,103879,2323,181501,27547,1028067,942060,526579,738048,1045534,20208,767584,942337,584588,1020748,891653,656178,1010742,15514,952700,549537,319092,603105,469495,906584,311859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003908s ]