SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045503 LIMIT 1 [ RunTime:0.001556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045503 [ RunTime:0.004008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488412,328363,396536,302887,9835,685192,942800,774899,859649,4027,1028222,684685,1046555,725585,657378,935913,713864,138459,49217,954017,1043675,758189,281350,827563,198748,229014,80808,376606,65541,479836,94159,145346,556615,855803,747817,411229,142803,133796,162362,633765,1007902,235388,68402,27849,128656,230898,49468,954081,427054,657211,1045761,619167,386117,745567,119766,508923,261170,1003291,823594,1016293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001755s ]