SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041198 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041198 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215748,771364,765045,974636,134787,935612,147198,422779,462816,74488,940988,118399,1002339,447105,225990,454402,263031,647872,254459,803505,934064,534127,484672,229016,25363,1036654,62953,229649,94934,15133,865432,3448,414186,330881,97690,182143,724376,605297,22824,524329,1016799,175489,535328,510691,497542,412864,345769,418478,1765,996246,1024787,259107,766551,252231,845774,81376,541481,600924,88144,583035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]