SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045106 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045106 [ RunTime:0.002223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914026,924855,933898,786810,863283,380590,678891,86380,203036,848475,277604,538056,603793,757106,392433,265693,633862,69138,156682,909123,510778,833105,957500,445432,213303,917467,925785,165986,157003,156336,982026,828757,12393,968163,941187,593925,325359,706421,428767,516894,789746,820567,1030039,218720,418444,345756,781936,195375,917535,485039,329104,927747,166929,70306,7233,469507,542932,91611,466489,837338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]