SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102093 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102093 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224732,111009,380256,575349,114415,611855,453944,524112,108885,456616,117013,373358,123471,180652,945687,707492,277432,887784,94101,183819,80656,628929,328846,389787,441803,627755,661275,296499,67746,35645,454970,555342,776917,356186,867690,635466,477975,52028,656751,874733,344314,46490,124740,635482,667717,425775,46347,1033855,492369,778267,72400,570313,440563,965603,592589,198502,602590,788372,400592,407050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]