SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001651s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028484 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028484 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66877,896149,551243,300574,622683,1031361,790030,820189,831963,965600,53478,120345,919078,142898,624896,652805,707666,78445,718149,613201,296803,208939,293633,37445,531283,579880,837898,234656,51595,760764,248571,709068,1040995,440226,1025286,527310,688629,391681,137779,679415,822405,383666,824177,882506,429680,500895,849444,858889,657670,190356,679161,101722,592511,354643,532844,437784,139581,505583,623021,760739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]