SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038422 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038422 [ RunTime:0.004343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46476,211432,205543,49784,577197,20471,368688,938464,892673,648147,492589,397473,171330,527315,142680,291410,378208,786302,827337,526687,819108,661432,484418,436096,565256,895574,150091,265564,162892,14995,520691,264929,509442,439476,464762,722868,156493,779248,539364,45114,721641,108936,978388,388845,834049,131047,427746,64453,136280,910377,720059,941719,295292,842816,253543,282170,332121,54229,195779,100472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001018s ]