SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005103 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005103 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307007,231960,760863,601598,522921,577548,95424,26621,511631,576361,666744,99821,725439,15540,901721,730747,701967,40760,819377,289906,161920,841169,185055,722286,709598,220418,451097,980814,996731,99265,398226,229618,732528,802629,554247,83285,576086,240309,474169,117553,622146,134454,894259,684162,200290,655062,49174,579743,652005,431547,383288,867064,583690,174817,55762,478072,826709,459602,310043,358056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]