SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040303 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040303 [ RunTime:0.007877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161168,173098,185048,682534,854080,538005,71323,174144,151314,722076,723530,1012383,748059,149022,248711,936276,961060,579232,439323,631848,619857,819083,577265,77134,715040,854756,855400,467963,1037328,841159,921775,397100,187237,449192,645160,699631,280602,427077,211937,760967,980797,47796,972017,597199,945400,310109,516983,344894,181035,612410,914482,715680,531785,158450,743705,792841,72845,753851,20254,386307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]