SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481017 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481017 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21113,794569,38962,365274,26005,97878,158376,680588,972869,993765,793269,582046,1026283,807089,472557,770855,377570,33965,899757,672186,955109,935718,694377,175527,490857,746518,565384,771117,188397,765192,7207,789514,342717,474021,600687,743161,842952,14820,752547,113082,138288,427364,490320,272392,491218,998556,274478,318369,369442,520439,593822,320787,641418,847805,153227,137875,348252,505451,423172,447462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]