SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813309 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813309 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510159,1028953,845047,15316,444298,343487,276970,495294,722742,1009421,415571,137518,401007,149927,160554,916825,102891,60727,936926,798314,606260,13949,703318,300298,1001371,166860,245941,641867,585404,1041332,651802,508624,496441,861322,79150,659873,528343,385321,743924,527393,306974,660821,339740,136962,429986,347379,9211,903352,970417,999684,886585,911069,937995,651615,772394,199439,17284,624732,174970,949173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]