SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003013s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447654 LIMIT 1 [ RunTime:0.000763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447654 [ RunTime:0.008456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61802,696754,28145,417547,868446,160785,449067,899181,465683,977712,243101,808584,800297,304734,532318,455683,1014629,410568,735302,481879,816505,983957,956336,969637,574832,971678,95153,624406,260790,603539,181612,169686,348212,219733,805782,319811,42062,1015777,560721,619954,606778,691143,176809,62998,720870,103349,502288,539659,548303,343367,428444,349940,331534,191028,270219,736039,696644,695759,877151,4608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]