SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344272 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344272 [ RunTime:0.002157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902852,169806,372268,370064,927296,78003,609508,313463,667332,877666,62388,658618,568590,1010011,425024,1040096,648351,940692,395455,411479,41707,6059,528587,971940,969788,277176,691075,809895,1015774,852686,712016,1047720,991595,256486,220037,950008,325689,641837,292562,300951,353284,364639,911038,67600,1008521,115191,650806,984424,158035,1023381,581613,674268,238149,128814,816408,460798,674531,804751,731282,281134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]