SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542503 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542503 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501552,935646,366514,479607,600679,13445,359550,54785,430610,526492,694116,768115,371924,434638,994709,821431,491646,198244,138327,463419,927329,985862,729309,241335,461527,612856,284512,304132,836624,982074,567349,773498,289434,813764,440106,464983,766087,1033697,984867,805428,383890,545175,341338,901992,299081,857672,642952,65827,230046,157723,613818,517882,224286,339701,1018244,608817,443477,209715,1031660,475077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]