SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40103 LIMIT 1 [ RunTime:0.004834s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40103 [ RunTime:0.005131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841764,678669,427712,49160,701257,97872,912798,736131,817649,152786,159748,120955,9186,356333,185932,251488,442247,328130,763808,940982,722123,436516,511731,379474,505339,168445,785777,519554,21546,544375,421400,812942,9348,36097,203217,923908,255370,334765,557361,295153,555619,251867,526000,704471,169012,896160,309222,304178,79169,654863,757717,727306,904229,216283,590244,986952,482545,192927,205123,990224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001107s ]