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` = 388818 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388818 [ RunTime:0.003872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947333,712435,763721,928955,175727,582610,633540,820601,205375,377601,327731,1037192,490298,448992,161331,1013090,262341,384670,86208,168185,275937,418702,602704,837721,443675,158787,123329,978956,356209,231359,127091,841580,262717,110966,976263,204077,336766,438123,216779,1039868,1031,311223,655743,501717,291286,375237,1001471,517281,304104,973228,741098,84674,11136,324022,656182,25618,473948,884165,340420,181267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]