SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042176 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042176 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251795,930605,590222,137295,948596,390068,227958,810317,534748,733327,17228,181924,794878,1041022,94284,470747,718054,558044,338940,813487,976773,624943,1000996,663306,854056,518538,886126,152802,606934,204966,250395,772351,113018,886613,686280,344376,16738,861249,562759,244022,77308,264981,504499,448603,1013510,211065,832625,849478,86146,971190,328758,989513,762227,379181,342250,373202,382817,71642,723966,252135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001593s ]