SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527629 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527629 [ RunTime:0.003652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26285,409596,787485,1039109,1016255,173710,821095,100009,10265,613948,83897,830872,780987,41996,295325,986574,566948,224034,374537,540779,212456,819512,214424,1042557,728174,189584,486632,722242,960099,19294,543414,742035,533592,362206,593730,308314,183126,751748,374656,954856,519520,656722,868501,478645,153517,135722,279379,274175,442423,975075,415811,748953,185665,618427,279707,454632,1030946,911101,654295,481674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001576s ]