SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431001 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431001 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959804,554923,25002,255464,170742,409914,335458,933258,888383,6748,818498,1044271,525416,541545,154454,246194,222917,267924,132812,791390,10274,512124,786944,528546,13958,528059,763683,121741,295116,450141,6654,916643,341189,827049,88453,47716,248642,849320,221209,530010,815602,409645,481432,171605,840205,843322,164427,835803,1043893,395682,419161,256476,42305,543720,382692,256408,445317,312901,1004280,663065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]