SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252218 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252218 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805659,619098,482799,864598,590575,828836,328027,32152,387690,387693,342173,1045848,747967,269592,721504,18132,266993,194322,445578,943201,471054,182488,822674,194006,747916,542020,665127,449135,606673,721565,23708,263840,836322,981423,968469,994214,527284,20025,621617,230763,312174,1018286,1001214,708026,273045,464600,613718,14757,507469,1035339,949827,1025809,131125,614294,654097,858436,340959,427059,732597,385514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]