SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541428 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541428 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317344,566905,457508,1022031,97635,495305,1029007,484800,434295,551067,172686,423514,388173,115877,629366,948042,327237,192110,1007463,391564,576235,720442,99706,198178,398994,237176,774554,441490,929706,452619,977239,763890,573888,667674,909432,1030235,928028,235373,724930,353764,665638,198223,231604,829554,98936,744884,66620,276492,745804,673678,34811,335491,210818,956562,953417,27398,558230,494072,288910,443407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]