SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378991 LIMIT 1 [ RunTime:0.001195s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378991 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618040,541470,306705,1030588,28720,28608,1031740,125643,6989,793715,552560,128920,495636,505362,1007257,578102,1033670,730919,93931,248430,874897,909636,1028129,268249,276237,947075,66966,791063,685480,182061,522422,451281,626135,15295,472202,357726,775345,142571,236063,434250,520600,133278,771882,358679,700821,318702,261288,194080,998184,111284,343835,112951,600192,1005640,905855,406665,886208,110691,489074,622125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.034375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002768s ]