SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415041 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415041 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936229,517775,316222,570619,25665,688537,139386,131382,1000831,750850,245634,87505,968745,963940,536844,106729,495675,966893,464313,60376,629165,175861,999244,97875,592954,1979,445729,503826,343276,491405,418449,1032931,933039,697676,455165,370554,640919,964602,317717,581636,1003834,420000,643439,845425,302358,278109,859288,195643,806609,815996,226810,160726,11330,347219,662885,228534,106434,477899,588713,113839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]