SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041021 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041021 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856552,91883,554406,710068,81564,964748,953672,905611,45939,331570,270936,700781,274759,850128,339514,593805,884703,25454,421042,464179,845659,268411,418376,86361,79683,916715,388523,93189,866076,4319,673632,40092,526364,384412,961751,29642,528034,45902,966889,411700,537563,196859,984586,287606,81,173867,213293,680680,195571,812636,908544,475474,105117,587754,947779,943362,962818,403456,330797,393571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]