SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354218 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354218 [ RunTime:0.002366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896607,566213,884279,471842,261844,178022,716699,190622,774354,236463,924078,669869,124642,284146,242475,728652,169021,394129,613755,832340,314579,810409,866528,829189,885672,492255,50244,182393,811675,106173,322080,433678,863107,799905,327258,91213,905284,103373,416022,21983,354691,717398,373822,363,1045762,507800,669608,929429,760332,552917,302750,21785,390835,620923,495004,799674,990923,854539,617021,657740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]