SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199821 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199821 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412913,911039,920569,112867,696790,30610,380865,556523,636760,275776,393629,577642,931168,644324,1002065,103117,392897,914066,1043741,34454,864241,374450,97777,894515,964535,153697,267837,975805,416393,931052,985802,757232,527260,186195,312027,567746,58546,80588,18267,70112,752711,974455,763551,976079,900011,422312,1023320,938290,716986,882195,349237,516864,312901,12316,82922,22861,611661,612747,417923,784446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]