SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429713 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429713 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009038,942266,478014,102542,129288,186449,288346,6862,932295,355508,79673,539207,80123,949151,399218,704870,359998,251092,426630,63739,450509,408663,699942,13362,528251,327458,183444,327902,162683,772246,129371,523589,429024,600250,962102,410466,819478,144076,162299,1014338,327417,133737,440589,338941,151305,432627,58609,47617,240263,959818,599032,484247,922860,657854,10860,239680,845448,859060,72460,462387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]