SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198403 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198403 [ RunTime:0.001390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102179,707648,972929,553361,446956,10397,783901,972961,534326,426336,166378,821563,518196,327341,1036664,209563,932860,536721,709292,11169,166131,50202,964176,1017887,1005816,438430,807741,195184,120051,377588,665383,795022,239900,237101,982610,382815,443083,915908,741336,1047304,870171,689366,120768,594223,122247,446095,500403,202014,528896,644833,301373,966114,717782,561423,125400,1017187,279866,715056,889111,204863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000877s ]