SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10146 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10146 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765740,756773,671290,60273,275373,527072,1012728,423209,579988,362958,21377,168143,1039694,613450,983050,1031919,33003,294413,817813,152908,858617,446217,189224,660788,348080,374978,900179,518452,706524,222665,447242,216748,66415,837161,860727,686105,500547,721606,635122,707749,379137,158927,74618,951601,692894,187358,442121,482251,482625,29411,948882,1015414,557778,161697,514939,425648,963379,747425,456841,423607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]